Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 23446 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 1 |
| Duplicate rows (%) | < 0.1% |
| Total size in memory | 2.5 MiB |
| Average record size in memory | 112.0 B |
Variable types
| Categorical | 1 |
|---|---|
| Numeric | 12 |
| Dataset has 1 (< 0.1%) duplicate rows | Duplicates |
chlorophyll is highly skewed (γ1 = 51.65583126) | Skewed |
nitrate_mean has 767 (3.3%) zeros | Zeros |
chlorophyll has 1529 (6.5%) zeros | Zeros |
Reproduction
| Analysis started | 2023-02-02 21:39:07.597779 |
|---|---|
| Analysis finished | 2023-02-02 21:39:17.550002 |
| Duration | 9.95 seconds |
| Software version | ydata-profiling vv4.0.0 |
| Download configuration | config.json |
siteid
Categorical
| Distinct | 24 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 366.3 KiB |
| ARIK | 1096 |
|---|---|
| LECO | 1096 |
| WALK | 1096 |
| SYCA | 1096 |
| PRIN | 1096 |
| Other values (19) |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 93784 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ARIK |
|---|---|
| 2nd row | ARIK |
| 3rd row | ARIK |
| 4th row | ARIK |
| 5th row | ARIK |
Common Values
| Value | Count | Frequency (%) |
| ARIK | 1096 | 4.7% |
| LECO | 1096 | 4.7% |
| WALK | 1096 | 4.7% |
| SYCA | 1096 | 4.7% |
| PRIN | 1096 | 4.7% |
| POSE | 1096 | 4.7% |
| MCRA | 1096 | 4.7% |
| MCDI | 1096 | 4.7% |
| MAYF | 1096 | 4.7% |
| LEWI | 1096 | 4.7% |
| Other values (14) | 12486 |
Length
| Value | Count | Frequency (%) |
| arik | 1096 | 4.7% |
| mayf | 1096 | 4.7% |
| como | 1096 | 4.7% |
| leco | 1096 | 4.7% |
| king | 1096 | 4.7% |
| wlou | 1096 | 4.7% |
| lewi | 1096 | 4.7% |
| hopb | 1096 | 4.7% |
| mcdi | 1096 | 4.7% |
| mcra | 1096 | 4.7% |
| Other values (14) | 12486 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 8547 | 9.1% |
| I | 7767 | 8.3% |
| E | 7644 | 8.2% |
| L | 7012 | 7.5% |
| O | 6968 | 7.4% |
| A | 6922 | 7.4% |
| R | 6837 | 7.3% |
| M | 5451 | 5.8% |
| B | 4692 | 5.0% |
| P | 4247 | 4.5% |
| Other values (11) | 27697 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 93784 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 8547 | 9.1% |
| I | 7767 | 8.3% |
| E | 7644 | 8.2% |
| L | 7012 | 7.5% |
| O | 6968 | 7.4% |
| A | 6922 | 7.4% |
| R | 6837 | 7.3% |
| M | 5451 | 5.8% |
| B | 4692 | 5.0% |
| P | 4247 | 4.5% |
| Other values (11) | 27697 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 93784 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 8547 | 9.1% |
| I | 7767 | 8.3% |
| E | 7644 | 8.2% |
| L | 7012 | 7.5% |
| O | 6968 | 7.4% |
| A | 6922 | 7.4% |
| R | 6837 | 7.3% |
| M | 5451 | 5.8% |
| B | 4692 | 5.0% |
| P | 4247 | 4.5% |
| Other values (11) | 27697 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 93784 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| C | 8547 | 9.1% |
| I | 7767 | 8.3% |
| E | 7644 | 8.2% |
| L | 7012 | 7.5% |
| O | 6968 | 7.4% |
| A | 6922 | 7.4% |
| R | 6837 | 7.3% |
| M | 5451 | 5.8% |
| B | 4692 | 5.0% |
| P | 4247 | 4.5% |
| Other values (11) | 27697 |
nitrate_mean
Real number (ℝ)
| Distinct | 11109 |
|---|---|
| Distinct (%) | 47.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.413306 |
| Minimum | 0 |
|---|---|
| Maximum | 851.7 |
| Zeros | 767 |
| Zeros (%) | 3.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.32083333 |
| Q1 | 2.7708333 |
| median | 6.1 |
| Q3 | 21.471615 |
| 95-th percentile | 169.37135 |
| Maximum | 851.7 |
| Range | 851.7 |
| Interquartile range (IQR) | 18.700781 |
Descriptive statistics
| Standard deviation | 45.372328 |
|---|---|
| Coefficient of variation (CV) | 2.0243478 |
| Kurtosis | 14.711481 |
| Mean | 22.413306 |
| Median Absolute Deviation (MAD) | 4.7177083 |
| Skewness | 3.4880563 |
| Sum | 525502.38 |
| Variance | 2058.6481 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 767 | 3.3% |
| 3.3 | 33 | 0.1% |
| 6.1 | 32 | 0.1% |
| 3.55 | 32 | 0.1% |
| 3.633333333 | 29 | 0.1% |
| 3.65 | 29 | 0.1% |
| 2.75 | 29 | 0.1% |
| 3.14375 | 27 | 0.1% |
| 4.55 | 26 | 0.1% |
| 2.652083333 | 25 | 0.1% |
| Other values (11099) | 22417 |
| Value | Count | Frequency (%) |
| 0 | 767 | |
| 0.001041666667 | 1 | < 0.1% |
| 0.002222222222 | 1 | < 0.1% |
| 0.003333333333 | 1 | < 0.1% |
| 0.007291666667 | 1 | < 0.1% |
| 0.008333333333 | 1 | < 0.1% |
| 0.00989010989 | 1 | < 0.1% |
| 0.01041666667 | 1 | < 0.1% |
| 0.01136363636 | 1 | < 0.1% |
| 0.01354166667 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 851.7 | 1 | |
| 493.6 | 1 | |
| 284.4541667 | 1 | |
| 264.3375 | 1 | |
| 261.76875 | 1 | |
| 261.3 | 1 | |
| 260.85625 | 1 | |
| 260.5569231 | 1 | |
| 259.7614583 | 1 | |
| 259.6916667 | 1 |
specific_conductance
Real number (ℝ)
| Distinct | 19471 |
|---|---|
| Distinct (%) | 83.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 583.87356 |
| Minimum | 6.25 × 10-5 |
|---|---|
| Maximum | 215585.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.3 KiB |
Quantile statistics
| Minimum | 6.25 × 10-5 |
|---|---|
| 5-th percentile | 13.48777 |
| Q1 | 37.768763 |
| median | 117.8826 |
| Q3 | 508.94584 |
| 95-th percentile | 685.11138 |
| Maximum | 215585.2 |
| Range | 215585.2 |
| Interquartile range (IQR) | 471.17707 |
Descriptive statistics
| Standard deviation | 6249.5379 |
|---|---|
| Coefficient of variation (CV) | 10.703581 |
| Kurtosis | 383.47817 |
| Mean | 583.87356 |
| Median Absolute Deviation (MAD) | 98.911444 |
| Skewness | 19.25644 |
| Sum | 13689500 |
| Variance | 39056724 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 573.7750452 | 11 | < 0.1% |
| 34.77873521 | 11 | < 0.1% |
| 39.03122434 | 10 | < 0.1% |
| 37.93636806 | 10 | < 0.1% |
| 38.13544444 | 9 | < 0.1% |
| 466.7478697 | 9 | < 0.1% |
| 652.2436736 | 9 | < 0.1% |
| 38.02676389 | 9 | < 0.1% |
| 206.4707743 | 9 | < 0.1% |
| 111.3831285 | 9 | < 0.1% |
| Other values (19461) | 23350 |
| Value | Count | Frequency (%) |
| 6.25 × 10-5 | 1 | |
| 0.001541666667 | 1 | |
| 0.005796852077 | 1 | |
| 0.00871438499 | 1 | |
| 0.01110923771 | 1 | |
| 0.01912358986 | 1 | |
| 0.02366180362 | 1 | |
| 0.02713880685 | 1 | |
| 0.02773611111 | 1 | |
| 0.02871527778 | 1 |
| Value | Count | Frequency (%) |
| 215585.1969 | 1 | < 0.1% |
| 118086.5914 | 1 | < 0.1% |
| 118034.1458 | 1 | < 0.1% |
| 118032.4041 | 1 | < 0.1% |
| 118026.3421 | 1 | < 0.1% |
| 118017.1726 | 1 | < 0.1% |
| 118014.5285 | 1 | < 0.1% |
| 118010.4898 | 1 | < 0.1% |
| 118006.4988 | 6 | |
| 118001.9287 | 6 |
DO
Real number (ℝ)
| Distinct | 19409 |
|---|---|
| Distinct (%) | 82.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.483089 |
| Minimum | 0 |
|---|---|
| Maximum | 354.97759 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4.6670184 |
| Q1 | 8.2260217 |
| median | 9.6660955 |
| Q3 | 11.095766 |
| 95-th percentile | 13.169993 |
| Maximum | 354.97759 |
| Range | 354.97759 |
| Interquartile range (IQR) | 2.869744 |
Descriptive statistics
| Standard deviation | 16.81019 |
|---|---|
| Coefficient of variation (CV) | 1.6035532 |
| Kurtosis | 296.20879 |
| Mean | 10.483089 |
| Median Absolute Deviation (MAD) | 1.4369149 |
| Skewness | 16.943946 |
| Sum | 245786.49 |
| Variance | 282.58249 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8.708430556 | 11 | < 0.1% |
| 12.08062847 | 10 | < 0.1% |
| 9.987256944 | 10 | < 0.1% |
| 8.924236111 | 9 | < 0.1% |
| 8.059923611 | 9 | < 0.1% |
| 9.389659722 | 9 | < 0.1% |
| 7.731243056 | 9 | < 0.1% |
| 4.162380764 | 9 | < 0.1% |
| 3.218755378 | 9 | < 0.1% |
| 8.680909722 | 9 | < 0.1% |
| Other values (19399) | 23352 |
| Value | Count | Frequency (%) |
| 0 | 3 | |
| 0.2234930556 | 1 | < 0.1% |
| 0.2289583333 | 1 | < 0.1% |
| 0.2346944444 | 1 | < 0.1% |
| 0.535875 | 1 | < 0.1% |
| 0.5426909722 | 1 | < 0.1% |
| 0.5442743056 | 1 | < 0.1% |
| 0.5455208333 | 1 | < 0.1% |
| 0.5476666667 | 1 | < 0.1% |
| 0.5570833333 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 354.9775903 | 1 | < 0.1% |
| 350.844588 | 1 | < 0.1% |
| 350.2903487 | 1 | < 0.1% |
| 348.9448664 | 5 | |
| 345.6860347 | 1 | < 0.1% |
| 344.8827361 | 1 | < 0.1% |
| 344.8493507 | 4 | |
| 343.2838435 | 1 | < 0.1% |
| 342.7693021 | 1 | < 0.1% |
| 339.5286148 | 1 | < 0.1% |
pH
Real number (ℝ)
| Distinct | 19078 |
|---|---|
| Distinct (%) | 81.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.5137891 |
| Minimum | 0.0025 |
|---|---|
| Maximum | 13.790451 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.3 KiB |
Quantile statistics
| Minimum | 0.0025 |
|---|---|
| 5-th percentile | 5.7870911 |
| Q1 | 7.1478749 |
| median | 7.6311563 |
| Q3 | 7.9749115 |
| 95-th percentile | 8.3077426 |
| Maximum | 13.790451 |
| Range | 13.787951 |
| Interquartile range (IQR) | 0.8270366 |
Descriptive statistics
| Standard deviation | 0.87651541 |
|---|---|
| Coefficient of variation (CV) | 0.11665425 |
| Kurtosis | 12.338036 |
| Mean | 7.5137891 |
| Median Absolute Deviation (MAD) | 0.40040672 |
| Skewness | -0.19135221 |
| Sum | 176168.3 |
| Variance | 0.76827926 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7.960267361 | 11 | < 0.1% |
| 7.9386875 | 10 | < 0.1% |
| 7.701305556 | 10 | < 0.1% |
| 8.078440972 | 10 | < 0.1% |
| 9.183684028 | 10 | < 0.1% |
| 6.944145833 | 10 | < 0.1% |
| 7.885038194 | 9 | < 0.1% |
| 7.507246528 | 9 | < 0.1% |
| 7.674159722 | 9 | < 0.1% |
| 7.505371528 | 9 | < 0.1% |
| Other values (19068) | 23349 |
| Value | Count | Frequency (%) |
| 0.0025 | 1 | < 0.1% |
| 0.02 | 1 | < 0.1% |
| 0.04 | 3 | |
| 0.04670833333 | 1 | < 0.1% |
| 0.06 | 2 | |
| 0.0805625 | 1 | < 0.1% |
| 0.09507638889 | 1 | < 0.1% |
| 0.09948611111 | 1 | < 0.1% |
| 0.1049166667 | 1 | < 0.1% |
| 0.1092361111 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 13.79045139 | 1 | |
| 13.68230208 | 1 | |
| 13.60482168 | 1 | |
| 13.50673628 | 1 | |
| 13.49504167 | 1 | |
| 13.47515278 | 1 | |
| 13.45948958 | 1 | |
| 13.41638647 | 1 | |
| 13.37937153 | 1 | |
| 13.36761084 | 1 |
chlorophyll
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 18271 |
|---|---|
| Distinct (%) | 77.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 39.532824 |
| Minimum | 0 |
|---|---|
| Maximum | 59462.899 |
| Zeros | 1529 |
| Zeros (%) | 6.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.46566319 |
| median | 1.2444427 |
| Q3 | 4.2930165 |
| 95-th percentile | 102.89022 |
| Maximum | 59462.899 |
| Range | 59462.899 |
| Interquartile range (IQR) | 3.8273533 |
Descriptive statistics
| Standard deviation | 930.88464 |
|---|---|
| Coefficient of variation (CV) | 23.547133 |
| Kurtosis | 2866.5414 |
| Mean | 39.532824 |
| Median Absolute Deviation (MAD) | 1.043849 |
| Skewness | 51.655831 |
| Sum | 926886.58 |
| Variance | 866546.21 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1529 | 6.5% |
| 2.829520833 | 10 | < 0.1% |
| 1.342516154 | 10 | < 0.1% |
| 0.7168263889 | 9 | < 0.1% |
| 5.652826389 | 9 | < 0.1% |
| 8.596649306 | 9 | < 0.1% |
| 0.7444097222 | 9 | < 0.1% |
| 29.24377083 | 8 | < 0.1% |
| 2.651560881 | 8 | < 0.1% |
| 1.154545139 | 8 | < 0.1% |
| Other values (18261) | 21837 |
| Value | Count | Frequency (%) |
| 0 | 1529 | |
| 0.0009201388889 | 1 | < 0.1% |
| 0.0009513888889 | 1 | < 0.1% |
| 0.001169544893 | 1 | < 0.1% |
| 0.001333984445 | 1 | < 0.1% |
| 0.001489583333 | 1 | < 0.1% |
| 0.001690751445 | 1 | < 0.1% |
| 0.001847222222 | 1 | < 0.1% |
| 0.002135416667 | 1 | < 0.1% |
| 0.002392361111 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 59462.8986 | 1 | |
| 58945.07041 | 1 | |
| 54365.8061 | 1 | |
| 53169.06921 | 1 | |
| 47121.93829 | 1 | |
| 35084.85759 | 1 | |
| 31630.10413 | 1 | |
| 27480.42869 | 1 | |
| 26948.5032 | 1 | |
| 25381.5971 | 1 |
turbidity
Real number (ℝ)
| Distinct | 14734 |
|---|---|
| Distinct (%) | 62.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.8006177 |
| Minimum | 0 |
|---|---|
| Maximum | 99.988639 |
| Zeros | 9 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.31123611 |
| Q1 | 1.0980454 |
| median | 2.683687 |
| Q3 | 9.5134653 |
| 95-th percentile | 47.898694 |
| Maximum | 99.988639 |
| Range | 99.988639 |
| Interquartile range (IQR) | 8.4154199 |
Descriptive statistics
| Standard deviation | 16.964078 |
|---|---|
| Coefficient of variation (CV) | 1.7309192 |
| Kurtosis | 8.9260767 |
| Mean | 9.8006177 |
| Median Absolute Deviation (MAD) | 2.1232321 |
| Skewness | 2.9105889 |
| Sum | 229785.28 |
| Variance | 287.77994 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6.307083333 | 20 | 0.1% |
| 11.51238194 | 19 | 0.1% |
| 6.210263889 | 19 | 0.1% |
| 78.25515278 | 19 | 0.1% |
| 6.770125 | 18 | 0.1% |
| 2.968525281 | 18 | 0.1% |
| 51.03280556 | 18 | 0.1% |
| 18.27320833 | 18 | 0.1% |
| 9.185739583 | 18 | 0.1% |
| 1.348585823 | 18 | 0.1% |
| Other values (14724) | 23261 |
| Value | Count | Frequency (%) |
| 0 | 9 | |
| 0.0001319444444 | 1 | < 0.1% |
| 0.0005158678381 | 1 | < 0.1% |
| 0.001059459694 | 1 | < 0.1% |
| 0.001180555556 | 1 | < 0.1% |
| 0.001286269279 | 1 | < 0.1% |
| 0.002308008809 | 1 | < 0.1% |
| 0.003083333333 | 1 | < 0.1% |
| 0.003191978547 | 1 | < 0.1% |
| 0.003732638889 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 99.98863889 | 1 | < 0.1% |
| 99.89586806 | 1 | < 0.1% |
| 99.87997851 | 1 | < 0.1% |
| 99.85890278 | 1 | < 0.1% |
| 99.46018056 | 1 | < 0.1% |
| 99.44445139 | 6 | |
| 99.37908333 | 1 | < 0.1% |
| 99.35345486 | 1 | < 0.1% |
| 99.07136458 | 1 | < 0.1% |
| 98.91891262 | 1 | < 0.1% |
fDOM
Real number (ℝ)
| Distinct | 16179 |
|---|---|
| Distinct (%) | 69.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.379228 |
| Minimum | 0.0016666667 |
|---|---|
| Maximum | 298.34492 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.3 KiB |
Quantile statistics
| Minimum | 0.0016666667 |
|---|---|
| 5-th percentile | 1.184276 |
| Q1 | 5.9634218 |
| median | 15.809764 |
| Q3 | 35.193319 |
| 95-th percentile | 88.596172 |
| Maximum | 298.34492 |
| Range | 298.34326 |
| Interquartile range (IQR) | 29.229898 |
Descriptive statistics
| Standard deviation | 34.655744 |
|---|---|
| Coefficient of variation (CV) | 1.2657678 |
| Kurtosis | 12.715532 |
| Mean | 27.379228 |
| Median Absolute Deviation (MAD) | 11.616319 |
| Skewness | 3.0377977 |
| Sum | 641933.38 |
| Variance | 1201.0206 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15.45 | 22 | 0.1% |
| 45.22 | 19 | 0.1% |
| 27.7235625 | 14 | 0.1% |
| 1.601944444 | 14 | 0.1% |
| 15.12207447 | 14 | 0.1% |
| 25.38077778 | 14 | 0.1% |
| 20.45387955 | 14 | 0.1% |
| 109.2923125 | 13 | 0.1% |
| 13.39816667 | 13 | 0.1% |
| 0.4514305556 | 13 | 0.1% |
| Other values (16169) | 23296 |
| Value | Count | Frequency (%) |
| 0.001666666667 | 1 | < 0.1% |
| 0.001807628524 | 1 | < 0.1% |
| 0.00725 | 1 | < 0.1% |
| 0.009034722222 | 1 | < 0.1% |
| 0.009215277778 | 1 | < 0.1% |
| 0.01093055556 | 1 | < 0.1% |
| 0.01320138889 | 11 | |
| 0.01429861111 | 1 | < 0.1% |
| 0.01854861111 | 1 | < 0.1% |
| 0.01926388889 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 298.3449236 | 1 | < 0.1% |
| 295.7704514 | 1 | < 0.1% |
| 295.0840134 | 1 | < 0.1% |
| 292.856303 | 1 | < 0.1% |
| 291.973625 | 9 | |
| 287.3111135 | 1 | < 0.1% |
| 284.1592708 | 1 | < 0.1% |
| 283.9141528 | 1 | < 0.1% |
| 283.8414861 | 1 | < 0.1% |
| 283.0132083 | 1 | < 0.1% |
mean_temp
Real number (ℝ)
| Distinct | 17328 |
|---|---|
| Distinct (%) | 73.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.89726 |
| Minimum | 1.9013284 |
|---|---|
| Maximum | 31.721088 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.3 KiB |
Quantile statistics
| Minimum | 1.9013284 |
|---|---|
| 5-th percentile | 3.2524922 |
| Q1 | 7.109186 |
| median | 12.124423 |
| Q3 | 18.377882 |
| 95-th percentile | 23.883193 |
| Maximum | 31.721088 |
| Range | 29.819759 |
| Interquartile range (IQR) | 11.268696 |
Descriptive statistics
| Standard deviation | 6.7680836 |
|---|---|
| Coefficient of variation (CV) | 0.52476911 |
| Kurtosis | -1.0284933 |
| Mean | 12.89726 |
| Median Absolute Deviation (MAD) | 5.5913361 |
| Skewness | 0.26025395 |
| Sum | 302389.16 |
| Variance | 45.806956 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.302480655 | 49 | 0.2% |
| 4.348202381 | 12 | 0.1% |
| 16.21949648 | 12 | 0.1% |
| 3.839376488 | 12 | 0.1% |
| 10.03405655 | 12 | 0.1% |
| 21.83341964 | 12 | 0.1% |
| 7.926578656 | 12 | 0.1% |
| 9.31 | 12 | 0.1% |
| 4.677092458 | 12 | 0.1% |
| 11.32598958 | 12 | 0.1% |
| Other values (17318) | 23289 |
| Value | Count | Frequency (%) |
| 1.901328383 | 1 | < 0.1% |
| 1.903630952 | 1 | < 0.1% |
| 1.911272321 | 1 | < 0.1% |
| 1.911690476 | 1 | < 0.1% |
| 1.911869048 | 1 | < 0.1% |
| 1.912936012 | 1 | < 0.1% |
| 1.913133929 | 1 | < 0.1% |
| 1.916729167 | 1 | < 0.1% |
| 1.917998512 | 6 | |
| 1.920572917 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 31.7210878 | 1 | |
| 31.24484673 | 1 | |
| 31.05685565 | 1 | |
| 31.03692708 | 1 | |
| 30.89431548 | 1 | |
| 30.84168155 | 1 | |
| 30.71561905 | 1 | |
| 30.71248214 | 1 | |
| 30.58959821 | 1 | |
| 30.57940774 | 1 |
CH4_conc
Real number (ℝ)
| Distinct | 733 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.588224 |
| Minimum | 1.3109407 |
|---|---|
| Maximum | 1121.0379 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.3 KiB |
Quantile statistics
| Minimum | 1.3109407 |
|---|---|
| 5-th percentile | 1.7898706 |
| Q1 | 2.2888922 |
| median | 2.9568271 |
| Q3 | 6.5429576 |
| 95-th percentile | 46.94904 |
| Maximum | 1121.0379 |
| Range | 1119.727 |
| Interquartile range (IQR) | 4.2540654 |
Descriptive statistics
| Standard deviation | 79.515231 |
|---|---|
| Coefficient of variation (CV) | 4.7934748 |
| Kurtosis | 143.0286 |
| Mean | 16.588224 |
| Median Absolute Deviation (MAD) | 0.9100072 |
| Skewness | 11.210174 |
| Sum | 388927.49 |
| Variance | 6322.672 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14.60143328 | 80 | 0.3% |
| 3.71680165 | 80 | 0.3% |
| 2.658842758 | 80 | 0.3% |
| 2.512820683 | 70 | 0.3% |
| 2.363340225 | 67 | 0.3% |
| 1.7453277 | 55 | 0.2% |
| 2.34971865 | 55 | 0.2% |
| 1121.0379 | 54 | 0.2% |
| 19.9759255 | 51 | 0.2% |
| 1.74231325 | 51 | 0.2% |
| Other values (723) | 22803 |
| Value | Count | Frequency (%) |
| 1.310940717 | 32 | |
| 1.34711825 | 33 | |
| 1.347839808 | 35 | |
| 1.36316455 | 31 | |
| 1.457755 | 30 | |
| 1.478376767 | 35 | |
| 1.517455375 | 39 | |
| 1.534133375 | 37 | |
| 1.56372325 | 43 | |
| 1.569164775 | 31 |
| Value | Count | Frequency (%) |
| 1121.0379 | 54 | |
| 1099.988239 | 38 | |
| 507.196405 | 31 | |
| 406.1683071 | 31 | |
| 359.0325085 | 31 | |
| 348.6181527 | 31 | |
| 327.7892796 | 31 | |
| 292.5923172 | 30 | |
| 278.9625211 | 30 | |
| 272.9822939 | 31 |
CO2_conc
Real number (ℝ)
| Distinct | 733 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1303.4592 |
| Minimum | 451.65826 |
|---|---|
| Maximum | 11310.682 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.3 KiB |
Quantile statistics
| Minimum | 451.65826 |
|---|---|
| 5-th percentile | 607.96726 |
| Q1 | 740.02833 |
| median | 925.39724 |
| Q3 | 1308.5466 |
| 95-th percentile | 3981.2353 |
| Maximum | 11310.682 |
| Range | 10859.024 |
| Interquartile range (IQR) | 568.51831 |
Descriptive statistics
| Standard deviation | 1173.8768 |
|---|---|
| Coefficient of variation (CV) | 0.90058574 |
| Kurtosis | 17.864518 |
| Mean | 1303.4592 |
| Median Absolute Deviation (MAD) | 230.10609 |
| Skewness | 3.7830308 |
| Sum | 30560905 |
| Variance | 1377986.7 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1999.974753 | 80 | 0.3% |
| 652.4161503 | 80 | 0.3% |
| 921.5851002 | 80 | 0.3% |
| 628.4179888 | 70 | 0.3% |
| 675.6038126 | 67 | 0.3% |
| 1030.656109 | 55 | 0.2% |
| 726.9184898 | 55 | 0.2% |
| 4111.138738 | 54 | 0.2% |
| 1376.575813 | 51 | 0.2% |
| 846.5851382 | 51 | 0.2% |
| Other values (723) | 22803 |
| Value | Count | Frequency (%) |
| 451.658259 | 31 | |
| 468.3741605 | 30 | |
| 488.551533 | 33 | |
| 511.0961165 | 30 | |
| 517.5393612 | 36 | |
| 523.3695863 | 35 | |
| 530.5988639 | 31 | |
| 537.6745123 | 31 | |
| 538.5238653 | 30 | |
| 539.3033726 | 34 |
| Value | Count | Frequency (%) |
| 11310.68249 | 34 | |
| 8602.955041 | 29 | |
| 8470.422789 | 30 | |
| 7771.652797 | 32 | |
| 7545.073112 | 32 | |
| 7353.3547 | 40 | |
| 7223.292009 | 43 | |
| 6719.990008 | 30 | |
| 6232.460603 | 31 | |
| 6007.864268 | 31 |
N2O_conc
Real number (ℝ)
| Distinct | 733 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.64399083 |
| Minimum | 0.22668198 |
|---|---|
| Maximum | 17.283047 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.3 KiB |
Quantile statistics
| Minimum | 0.22668198 |
|---|---|
| 5-th percentile | 0.36388555 |
| Q1 | 0.4552329 |
| median | 0.55103137 |
| Q3 | 0.68916245 |
| 95-th percentile | 1.0130376 |
| Maximum | 17.283047 |
| Range | 17.056366 |
| Interquartile range (IQR) | 0.23392955 |
Descriptive statistics
| Standard deviation | 0.77868384 |
|---|---|
| Coefficient of variation (CV) | 1.2091536 |
| Kurtosis | 320.71324 |
| Mean | 0.64399083 |
| Median Absolute Deviation (MAD) | 0.11167857 |
| Skewness | 16.694549 |
| Sum | 15099.009 |
| Variance | 0.60634852 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.9247087083 | 80 | 0.3% |
| 0.721567075 | 80 | 0.3% |
| 0.6338136583 | 80 | 0.3% |
| 0.78556025 | 70 | 0.3% |
| 0.62038335 | 67 | 0.3% |
| 0.8191546 | 55 | 0.2% |
| 0.5856849625 | 55 | 0.2% |
| 0.761729675 | 54 | 0.2% |
| 0.49425745 | 51 | 0.2% |
| 0.4826633 | 51 | 0.2% |
| Other values (723) | 22803 |
| Value | Count | Frequency (%) |
| 0.226681975 | 40 | |
| 0.2495983375 | 34 | |
| 0.2542558375 | 31 | |
| 0.2703872 | 8 | < 0.1% |
| 0.2727544 | 32 | |
| 0.2744453444 | 39 | |
| 0.2811430167 | 24 | |
| 0.2830501167 | 31 | |
| 0.28345535 | 30 | |
| 0.2839153167 | 23 |
| Value | Count | Frequency (%) |
| 17.2830475 | 31 | |
| 11.27185817 | 30 | |
| 6.1993433 | 31 | |
| 2.70986205 | 33 | |
| 2.41977485 | 30 | |
| 1.997072 | 33 | |
| 1.675499875 | 30 | |
| 1.54271025 | 31 | |
| 1.42676645 | 31 | |
| 1.384639 | 29 |
Microbialabundanceper_ml
Real number (ℝ)
| Distinct | 635 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2469686 |
| Minimum | 4548.8889 |
|---|---|
| Maximum | 62606310 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.3 KiB |
Quantile statistics
| Minimum | 4548.8889 |
|---|---|
| 5-th percentile | 46090 |
| Q1 | 162276.67 |
| median | 328395.56 |
| Q3 | 1115775.6 |
| 95-th percentile | 14852501 |
| Maximum | 62606310 |
| Range | 62601761 |
| Interquartile range (IQR) | 953498.89 |
Descriptive statistics
| Standard deviation | 6659992.6 |
|---|---|
| Coefficient of variation (CV) | 2.6966961 |
| Kurtosis | 32.50246 |
| Mean | 2469686 |
| Median Absolute Deviation (MAD) | 234294.44 |
| Skewness | 5.0595365 |
| Sum | 5.7904257 × 1010 |
| Variance | 4.4355502 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 295747.7778 | 193 | 0.8% |
| 1281893.333 | 148 | 0.6% |
| 165637.7778 | 139 | 0.6% |
| 75857.77778 | 119 | 0.5% |
| 332715.5556 | 110 | 0.5% |
| 1223800 | 110 | 0.5% |
| 593895.5556 | 102 | 0.4% |
| 458984.4444 | 99 | 0.4% |
| 320713.3333 | 95 | 0.4% |
| 2596957.778 | 94 | 0.4% |
| Other values (625) | 22237 |
| Value | Count | Frequency (%) |
| 4548.888889 | 37 | |
| 9002.222222 | 39 | |
| 9048.888889 | 35 | |
| 12447.77778 | 33 | |
| 12975.55556 | 44 | |
| 13443.33333 | 31 | |
| 14207.77778 | 43 | |
| 16585.55556 | 35 | |
| 17764.44444 | 31 | |
| 19081.11111 | 37 |
| Value | Count | Frequency (%) |
| 62606310 | 33 | |
| 61982167.78 | 31 | |
| 59389574.44 | 40 | |
| 39993141.11 | 33 | |
| 39849108.89 | 30 | |
| 39465021.11 | 32 | |
| 35361682.22 | 33 | |
| 32692272.22 | 33 | |
| 32397805.56 | 33 | |
| 30390946.67 | 31 |
| siteid | nitrate_mean | specific_conductance | DO | pH | chlorophyll | turbidity | fDOM | mean_temp | CH4_conc | CO2_conc | N2O_conc | Microbialabundanceper_ml | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| date | |||||||||||||
| 2018-01-01 | ARIK | 13.700000 | 539.059444 | 10.186389 | 7.822500 | 2.095000 | 2.899444 | 45.220000 | 2.302481 | 25.792847 | 1621.722701 | 0.491186 | 52674.444444 |
| 2018-01-02 | ARIK | 13.700000 | 539.059444 | 10.186389 | 7.822500 | 2.095000 | 2.899444 | 45.220000 | 2.302481 | 25.792847 | 1621.722701 | 0.491186 | 52674.444444 |
| 2018-01-03 | ARIK | 13.700000 | 539.059444 | 10.186389 | 7.822500 | 2.095000 | 2.899444 | 45.220000 | 2.302481 | 25.792847 | 1621.722701 | 0.491186 | 52674.444444 |
| 2018-01-04 | ARIK | 12.535417 | 546.480042 | 9.921785 | 7.812403 | 3.249465 | 60.369840 | 45.220000 | 2.302481 | 25.792847 | 1621.722701 | 0.491186 | 52674.444444 |
| 2018-01-05 | ARIK | 10.310417 | 550.830208 | 9.721729 | 7.826743 | 5.565236 | 2.548007 | 45.220000 | 2.302481 | 25.792847 | 1621.722701 | 0.491186 | 52674.444444 |
| 2018-01-06 | ARIK | 9.966667 | 535.343569 | 10.060528 | 7.839222 | 8.422056 | 33.219167 | 45.220000 | 2.302481 | 25.792847 | 1621.722701 | 0.491186 | 52674.444444 |
| 2018-01-07 | ARIK | 9.207292 | 503.494465 | 10.333701 | 7.883479 | 9.204167 | 3.417035 | 45.220000 | 2.302481 | 25.792847 | 1621.722701 | 0.491186 | 52674.444444 |
| 2018-01-08 | ARIK | 8.103125 | 486.388582 | 10.645000 | 7.909354 | 12.090326 | 19.399326 | 45.220000 | 2.302481 | 25.792847 | 1621.722701 | 0.491186 | 52674.444444 |
| 2018-01-09 | ARIK | 7.708333 | 475.402592 | 10.650715 | 7.929910 | 43.929736 | 4.278028 | 17.590000 | 2.302481 | 25.792847 | 1621.722701 | 0.491186 | 52674.444444 |
| 2018-01-10 | ARIK | 6.932292 | 467.588493 | 10.577743 | 7.947944 | 30.268646 | 11.884910 | 0.451431 | 2.302481 | 25.792847 | 1621.722701 | 0.491186 | 52674.444444 |
| siteid | nitrate_mean | specific_conductance | DO | pH | chlorophyll | turbidity | fDOM | mean_temp | CH4_conc | CO2_conc | N2O_conc | Microbialabundanceper_ml | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| date | |||||||||||||
| 2020-12-22 | WLOU | 3.808333 | 110.893983 | 10.414507 | 8.093003 | 1.344167 | 1.889278 | 4.581035 | 15.160753 | 2.807956 | 805.804145 | 0.725995 | 54252.222222 |
| 2020-12-23 | WLOU | 3.822917 | 111.120556 | 10.408309 | 8.104146 | 0.989441 | 4.469233 | 4.638299 | 19.059426 | 2.807956 | 805.804145 | 0.725995 | 54252.222222 |
| 2020-12-24 | WLOU | 3.650000 | 111.481869 | 10.495976 | 8.103500 | 0.928238 | 2.389750 | 4.518500 | 7.926579 | 2.807956 | 805.804145 | 0.725995 | 54252.222222 |
| 2020-12-25 | WLOU | 54.902083 | 68.811199 | 10.619208 | 7.344299 | 2.661920 | 0.340674 | 27.655264 | 4.480490 | 2.807956 | 805.804145 | 0.725995 | 54252.222222 |
| 2020-12-26 | WLOU | 27.848958 | 630.318368 | 11.733611 | 7.820493 | 0.254809 | 0.722101 | 8.416081 | 21.252603 | 2.807956 | 805.804145 | 0.725995 | 54252.222222 |
| 2020-12-27 | WLOU | 0.000000 | 298.291892 | 11.899740 | 8.146028 | 0.220042 | 0.959097 | 16.215236 | 17.389786 | 2.807956 | 805.804145 | 0.725995 | 54252.222222 |
| 2020-12-28 | WLOU | 0.041758 | 12.105146 | 8.384253 | 6.651626 | 0.900684 | 2.639976 | 31.655028 | 10.173146 | 2.807956 | 805.804145 | 0.725995 | 54252.222222 |
| 2020-12-29 | WLOU | 4.188542 | 613.853512 | 10.900608 | 7.869108 | 9.817500 | 0.600420 | 4.082917 | 4.325874 | 2.807956 | 805.804145 | 0.725995 | 54252.222222 |
| 2020-12-30 | WLOU | 54.432292 | 176.735399 | 14.561951 | 7.948806 | 1.642281 | 2.160620 | 142.774583 | 3.839376 | 2.807956 | 805.804145 | 0.725995 | 54252.222222 |
| 2020-12-31 | WLOU | 54.080208 | 11.799757 | 12.442292 | 7.611872 | 10.631253 | 0.668552 | 54.251333 | 8.364247 | 2.807956 | 805.804145 | 0.725995 | 54252.222222 |
Most frequently occurring
| siteid | nitrate_mean | specific_conductance | DO | pH | chlorophyll | turbidity | fDOM | mean_temp | CH4_conc | CO2_conc | N2O_conc | Microbialabundanceper_ml | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | ARIK | 13.7 | 539.059444 | 10.186389 | 7.8225 | 2.095 | 2.899444 | 45.22 | 2.302481 | 25.792847 | 1621.722701 | 0.491186 | 52674.444444 | 3 |